mysql> #3 check schema and database model from lab#1
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| dbm449lab1         |
| devrydbm438        |
| devrystudent       |
| mysql              |
| newbaseball        |
| newtemp            |
| newtempstat        |
| performance_schema |
| sakila             |
| sampdb             |
| sys                |
| tempstatinc        |
| test               |
| world              |
+--------------------+
15 rows in set (0.00 sec)

mysql> use dbm449lab1;
Database changed
mysql> EXPLAIN 
    -> SELECT * FROM COURSE;
+----+-------------+--------+------------+------+---------------+------+---------+------+------+----------+-------+
| id | select_type | table  | partitions | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra |
+----+-------------+--------+------------+------+---------------+------+---------+------+------+----------+-------+
|  1 | SIMPLE      | COURSE | NULL       | ALL  | NULL          | NULL | NULL    | NULL |    5 |   100.00 | NULL  |
+----+-------------+--------+------------+------+---------------+------+---------+------+------+----------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> #4.Execute the following SQL query.  
mysql> # we can see the result is the same as displayed in Figure 1.
mysql> #6 Annotate the EXPLAIN output. I have defined what each of the fields mean as well as the implications of the results obtained. I will include the results of this step in the lab report. 
mysql> #7 CHECK POINT QUESTION answered 
mysql> #8 Execute the following SQL query
mysql> EXPLAIN
    -> SELECT * FROM COURSE
    -> ORDER BY COURSE_CODE;
+----+-------------+--------+------------+-------+---------------+---------+---------+------+------+----------+-------+
| id | select_type | table  | partitions | type  | possible_keys | key     | key_len | ref  | rows | filtered | Extra |
+----+-------------+--------+------------+-------+---------------+---------+---------+------+------+----------+-------+
|  1 | SIMPLE      | COURSE | NULL       | index | NULL          | PRIMARY | 24      | NULL |    5 |   100.00 | NULL  |
+----+-------------+--------+------------+-------+---------------+---------+---------+------+------+----------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> #9 CHECK POINT QUESTION
mysql> # the check point question has been answered and will be included in the lab report
mysql> #10.Carefully study, and then execute the following SQL query. Note that this table joins multiple tables in the WHERE clause.
mysql> EXPLAIN 
    -> SELECT COURSE_NAME, CLIENT_NAME, GRADE
    -> FROM COURSE c, COURSE_ACTIVITY ca, CLIENT cl
    -> WHERE c.COURSE_CODE = ca.COURSE_CODE AND ca.CLIENT_NO=cl.CLIENT_NO
    -> ORDER BY COURSE_NAME, CLIENT_NAME;
+----+-------------+-------+------------+--------+---------------+---------+---------+-------------------------+------+----------+----------------------------------------------------+
| id | select_type | table | partitions | type   | possible_keys | key     | key_len | ref                     | rows | filtered | Extra                                              |
+----+-------------+-------+------------+--------+---------------+---------+---------+-------------------------+------+----------+----------------------------------------------------+
|  1 | SIMPLE      | c     | NULL       | ALL    | PRIMARY       | NULL    | NULL    | NULL                    |    5 |   100.00 | Using temporary; Using filesort                    |
|  1 | SIMPLE      | ca    | NULL       | ALL    | NULL          | NULL    | NULL    | NULL                    |    6 |    16.67 | Using where; Using join buffer (Block Nested Loop) |
|  1 | SIMPLE      | cl    | NULL       | eq_ref | PRIMARY       | PRIMARY | 24      | dbm449lab1.ca.CLIENT_NO |    1 |   100.00 | NULL                                               |
+----+-------------+-------+------------+--------+---------------+---------+---------+-------------------------+------+----------+----------------------------------------------------+
3 rows in set, 1 warning (0.00 sec)

mysql> notee
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| dbm449lab1         |
| devrydbm438        |
| devrystudent       |
| mysql              |
| newbaseball        |
| newtemp            |
| newtempstat        |
| performance_schema |
| sakila             |
| sampdb             |
| sys                |
| tempstatinc        |
| test               |
| world              |
+--------------------+
15 rows in set (0.00 sec)

mysql> use dbm449lab1;
Database changed
mysql> #13 CHECK POINT QUESTION - careful analysis of both the EXPLAIN results
mysql> #Need to go back and review previous database course material, not clear what is wrong with the Data Model from lab #1 and what needs to be changed
mysql> notee